github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/manual_testing/many controls/queries/q15.sql (about)

     1  select
     2      -- Required Columns
     3      arn as resource,
     4      case
     5          when origin_groups ->> 'Items' is not null then 'ok'
     6          else 'alarm'
     7          end as status,
     8      case
     9          when origin_groups ->> 'Items' is not null then title || ' origin group is configured.'
    10          else title || ' origin group not configured.'
    11          end as reason,
    12      -- Additional Dimensions
    13      region,
    14      account_id
    15  from
    16      aws_cloudfront_distribution;